class CreateProjects < ActiveRecord::Migration
  def self.up
    create_table :projects do |t|
      t.string :name, :null => false
      t.text :description, :null => false
      t.string :create_by, :null => false
      t.timestamps :null => false
    end
    execute "ALTER TABLE `projects` CHANGE `updated_at` `updated_at` TIMESTAMP
    DEFAULT CURRENT_TIMESTAMP NOT NULL"
  end

  def self.down
    drop_table :projects
  end
end
